5 Reasons why XLookups are Better than VLookups
If you learned VLookup to do your table consolidations, you need to check out the new XLookup functi ...View More
Compa Ratio Explained
This video discusses what a compa-ratio is and how companies use it. Whether you are in HR and don't ...View More
Using Index and Match Functions in Excel to Derive a Value from a Matrix Table
This video provides step-by-step instructions on how to leverage the Index and Match functions withi ...View More
Why companies use pay ranges
It's common knowledge that many companies use pay ranges for positions to control how much any perso ...View More
Excel Pivots in 10 Minutes
Learn to use Excel Pivot tables and how to manipulate the data in under ten minutes. Agenda Introduc ...View More
Barriers to Communication
When we communicate, there are barriers that can lead to miscommunications. Common barriers interfer ...View More
The Communication Process
The communication process consists of a sender who encodes a message and transmits it through a chan ...View More
V Lookups Made Easy
Learn the basics of successful V-Lookups in Microsoft Excel. This video walks through the basics in ...View More
HR Tips - Starting Market Surveys for Hard-to-Match Jobs
What do you do when you are finding market matches for your jobs, but have those consistently annoyi ...View More
How I saved days of work by using VBA for Excel to break out my spreadsheets (A how to video)
In this video, I provide a step-by-step demonstration of how to take a master excel report and break ...View More